{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Summary","Detail","Cashflow"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Red Light Cameras provided by"]
[" American Traffic Solutions"]
["Red Light Cameras"]
["Revenue"]
["Number of Cameras",null,4]
[]
["Amount of Revenue Generated from Cameras",null,{"$f":"+Detail!E15","v":59520}]
["School Zone Cameras"]
["Revenue"]
["Number of Cameras",null,2]
[]
[]
["Amount of Revenue Generated from Cameras",null,{"$f":"+Detail!C28","v":45360}]
[]
["Total Monthly Revenue","001 3821 234 4293",{"$f":"C13+C7","v":104880}]
[]
["Expenses"]
[]
["American Traffic Solutions Monthly fee per Camera","001 5821 234 4931",28500]
[]
["American Traffic Solutions per ticket charge","001 5821 234 4930",9000]
[]
["Training on review of cameras and tickets-One time charge","001 5821 234 4301",8000]
[]
["Software Maineneance -Once a year","001 5821 234 4806",7000]
[]
["Computer Hardware-One time start up costs","001 5821 234 3504",8000]
[]
["Total  Monthly Expenses ",null,{"$f":"SUM(C19:C27)","v":60500}]
[]
[]
["Revenue - Annual ",null,{"$f":"C15*12","v":1258560}]
["Expenses - Annual",null,{"$f":"C29*12","v":726000}]
[]
["Net Revenue",null,{"$f":"C32-C33","v":532560}]

{"sheet":"Detail","index":1,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Red Light Cameras provided by"]
[" American Traffic Solutions"]
["Red Light Cameras"]
["Revenue"]
["Number of Cameras",1,2,3,4]
[]
["Average number of Violations captured per day ",10,20,30,40]
[]
["Average number of violations paid per day ",4,8,12,16]
[]
["Average number of violations paid per month(based on a 30 day month)",120,240,360,480]
[]
["Amount of fine for running a red light",124,124,124,124]
[]
["Amount of Revenue Generated from Cameras",{"$f":"B13*B11","v":14880},{"$f":"C13*C11","v":29760},{"$f":"D13*D11","v":44640},{"$f":"E13*E11","v":59520},{"$f":"E15","v":59520}]
["School Zone Cameras"]
["Revenue"]
["Number of Cameras",1,2]
[]
["Average number of Violations captured per day ",10,20]
[]
["Average number of violations paid per day ",5,10]
[]
["Average number of violations paid per month(based on a 30 day month)",120,240]
[]
["Amount of fine for running a red light ",189,189]
[]
["Amount of Revenue Generated from Cameras",{"$f":"B26*B24","v":22680},{"$f":"C26*C24","v":45360},null,null,{"$f":"C28","v":45360}]
[]
["Total Monthly Revenue",{"$nulls":4},{"$f":"F15+F28","v":104880},{"$f":"F30*12","v":1258560},"001-5821 234 4293"]
["Expenses"]
["Number of Cameras",6]
[]
["American Traffic Solutions Monthly fee per Camera",4750,null,null,null,{"$f":"B34*B32","v":28500},null,"001-5821 234 4931"]
[]
["American Traffic Solutions per ticket charge",5,1800,null,null,{"$f":"C36*B36","v":9000},null,"001-5821 234 4930"]
[]
["Training on review of cameras and tickets-One time charge",2,4000,null,null,8000,null,"001-5821 234 4301"]
[]
[" Software Maineneance -Once a year",2,3500,null,null,{"$f":"C40*B40","v":7000},null,"001 5821 234 4806"]
[]
["Computer Hardware for one time startup costs-",2,4000,null,null,{"$f":"C42*B42","v":8000},null,"001 5821 234 3504"]
[]
["Total  Monthly Expenses ",{"$nulls":4},{"$f":"SUM(F34:F42)","v":60500},{"$f":"F44*12","v":726000}]
[]
["Net Revenue ",{"$nulls":5},{"$f":"G30-G44","v":532560}]

{"sheet":"Cashflow","index":2,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"Number","Cost","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Total"]
["Revenue",{"$nulls":6},"warnings",{"$nulls":8},{"$f":"SUM(E6:P6)","v":0}]
[null,"Cameras (10 per day & 40% collection)",6,{"$nulls":5},{"$f":"+(Detail!B15*4)+(Detail!B28*2)","v":104880},{"$f":"+I7","v":104880},{"$f":"+J7","v":104880},104880,104880,104880,104880,104880,{"$f":"SUM(E7:P7)","v":839040}]
[]
[]
["Expense"]
[null,"Camera Fee ($4,750 per camera)",6,4750,null,null,null,{"$f":"+C11*D11","v":28500},{"$f":"+H11","v":28500},{"$f":"+I11","v":28500},{"$f":"+J11","v":28500},28500,28500,28500,28500,28500,{"$f":"SUM(E11:P11)","v":256500}]
[null,"Per ticket charge ($5 x 10 per day per camera)",null,5,null,null,null,{"$f":"10*30*6*5","v":9000},{"$f":"+H12","v":9000},{"$f":"+I12","v":9000},{"$f":"+J12","v":9000},9000,9000,9000,9000,9000,81000]
[null,"Training (one time)",null,4000,null,null,{"$f":"+D13","v":4000},{"$nulls":9},4000]
[null,"Software Maintenance (per year)",null,7000,null,null,7000,{"$nulls":9},7000]
[null,"Police hardware for ticket review",{"$nulls":14},0]
[null,"Kiosk"]
[null,"Courtroom Computer Hardware & AV Equipment",null,20000,null,null,20000,{"$nulls":9},{"$f":"SUM(E17:P17)","v":20000}]
[null,"Patrol (20 hours / month)",0.12,100000,null,null,null,{"$f":"+$D$18/12*$C$18","v":1000},{"$f":"+H18","v":1000},{"$f":"+I18","v":1000},1000,1000,1000,1000,1000,1000,9000]
[null,"Prosecutor (20 hours / month)",0.12,100000,null,null,null,{"$f":"+$D$19/12*$C$19","v":1000},{"$f":"+H19","v":1000},{"$f":"+I19","v":1000},1000,1000,1000,1000,1000,1000,9000]
[null,"Court processor (20 hours / month)",1,66000,null,null,null,{"$f":"+$D$20/12*$C$20","v":5500},{"$f":"+H20","v":5500},5500,5500,5500,5500,5500,5500,5500,49500]
[null,"Judge Pro-tem (20 hours / month)",0.12,152991,null,null,null,{"$f":"+$D$21/12*$C$21","v":1529.9099999999999},{"$f":"+H21","v":1529.9099999999999},{"$f":"+I21","v":1529.9099999999999},1529.9099999999999,1529.9099999999999,1529.9099999999999,1529.9099999999999,1529.9099999999999,1529.9099999999999,13769.189999999999]
[]
[null,"Printing & forms",{"$nulls":4},1000,{"$f":"+G23","v":1000},{"$f":"+H23","v":1000},1000,1000,1000,1000,1000,1000,1000,{"$f":"SUM(E23:P23)","v":10000}]
[null,"Postage",null,{"$f":"10*30*6*0.45","v":810},null,null,null,{"$f":"+D24","v":810},{"$f":"+H24","v":810},810,810,810,810,810,810,810,7290]
[null,"Misc",{"$nulls":4},500,{"$f":"+G25","v":500},{"$f":"+H25","v":500},500,500,500,500,500,500,500,5000]
[null,"Delinquency Fee",0.3,{"$nulls":13},0]
[null,"ITSD Staff (60 hours)",null,2000,null,null,250,250,187.5,{"$f":"+I27","v":187.5},{"$f":"+J27","v":187.5},187.5,187.5,187.5,187.5,187.5,2000]
[null,"Accounting",{"$nulls":14},0]
[null,"Traffic Staff",{"$nulls":14},0]
["SUBTOTAL EXPENSES",null,null,null,{"$f":"SUM(E11:E29)","v":0},{"$f":"SUM(F11:F29)","v":0},{"$f":"SUM(G11:G29)","v":32750},{"$f":"SUM(H11:H29)","v":49089.91},49027.41,49027.41,49027.41,49027.41,49027.41,49027.41,49027.41,49027.41,474059.19000000018]
[]
[null,"Net",null,null,{"$f":"+E7-E30","v":0},{"$f":"+F7-F30","v":0},-32750,{"$f":"+H7-H30","v":-49089.91},{"$f":"+I7-I30","v":55852.59},55852.59,55852.59,55852.59,55852.59,55852.59,55852.59,55852.59,{"$f":"SUM(E32:P32)","v":364980.80999999994}]